Confusion with "is_encrypted" using TDE

Good morning,

I'm looking at TDE and am currently a little confused.

If I interrogate sys.databases, I see that myDatabase has the "is_encrypted" flag set to 0.

If I interrogate the sys.dm_encryption_keys view, under the correct database, I see that the encryption_state is set to 3 (which is Encrypted)...

Surely if the value for encryption_state is 3, then the "is_encrypted" flag should be 1?

Am I missing something?

Regards

Andy

October 7th, 2013 6:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics